home *** CD-ROM | disk | FTP | other *** search
/ Belgian Amiga Club - ADF Collection / BS1 part 60.zip / BS1 part 60 / Prof. Calc d3.adf / Financial / 5-Year Balance Sheet.PCF (.txt) next >
Gold Disk Spreadsheet  |  1991-12-11  |  7KB  |  133 lines
  1. Gadgets and Widgets INC
  2.      Balance Sheet
  3. Current Assets
  4.   Cash
  5. 12000
  6. 30000
  7. 10000
  8. 55000
  9. 100000
  10.   Accounts Receivable
  11. 35000
  12. 28000
  13. 25000
  14. 20000
  15. 15000
  16.   Inventory
  17. 91000
  18. 102000
  19. 150000
  20. 100000
  21. 80000
  22.   Raw Material
  23. 15000
  24. 17000
  25. 13000
  26. 10000
  27. 10000
  28.   Work-In-Progress
  29. 12000
  30.   Finished Goods
  31. 40000
  32. 50000
  33. 75000
  34. 49000
  35. 25000
  36.   Total Current Assets
  37. 201000
  38. 233000
  39. 278000
  40. 243000
  41. 242000
  42. Fixed Assets
  43.   Land
  44. 21000
  45.   Plant
  46. 355500
  47. 350500
  48. 330000
  49. 330000
  50. 380000
  51.   Equipment
  52. 250000
  53. 240000
  54. 250000
  55. 284500
  56. 300000
  57. Total Fixed Assets
  58. 605500
  59. 590500
  60. 580000
  61. 614500
  62. 701000
  63. Total Assets:
  64. 806500
  65. 823500
  66. 858000
  67. 857500
  68. 943000
  69. Current Liabilities
  70.   Accounts Payable
  71. 17000
  72. 19000
  73. 21000
  74. 25000
  75. 30000
  76.   Salaries Payable
  77. 10000
  78. 10000
  79.   Taxes Payable
  80.   Short-term Loans
  81. Total Liabilites
  82. 25000
  83. 28000
  84. 30500
  85. 41500
  86. 53000
  87. Long Term Debt
  88.   Term Loans
  89. 100000
  90. 100000
  91. 147500
  92. 100000
  93. 100000
  94.   Bond Issues
  95.   SBA Loans
  96. 115000
  97. 112000
  98. 100000
  99. 100000
  100. 100000
  101. Total Long-term Debt
  102. 215000
  103. 212000
  104. 247500
  105. 200000
  106. 200000
  107. Net Worth
  108.   Preferred Stock
  109.   Common Stock
  110. 300000
  111. 300000
  112. 300000
  113. 300000
  114. 300000
  115.   Retained Earnings
  116. 266500
  117. 283500
  118. 280000
  119. 316000
  120. 390000
  121. Total Net Worth
  122. 566500
  123. 583500
  124. 580000
  125. 616000
  126. 690000
  127. Liabilites + Equity
  128. 806500
  129. 823500
  130. 858000
  131. 857500
  132. 943000
  133.